﻿/********************************************************************************************************************
* Author:	Christos Polydorou																						*
* Email:	std04237@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_getuserdata" that returns all columns *
*			from the user with the specified username.																*
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_category_setStatus]
	@catid bigint,
	@status int
AS
	UPDATE Categories
	SET IsPrivate = @status
	WHERE Categories.ID = @catid
RETURN 0